package com.wc.dao;

import java.util.List;
import java.util.Map;

import com.wc.pojo.ExcelBean;
import org.apache.ibatis.annotations.Param;

import com.wc.pojo.User;

public interface UserMapper {

	// 新增用户
	int saveUser(User user) throws Exception;

	//批量插入用户
	void insertInfoBatchUser(List<User> list) throws Exception;

	// 根据身份证号码查询单个用户
	User getUseridcard(String idcard) throws Exception;

	// 删除用户
	int removeUser(String idcard) throws Exception;

	// 修改用户
	int updateUser(User user) throws Exception;
	
	// 根据用户名查询该用户数量
	int getCount(@Param("name") String name) throws Exception;

	// 分页列表+模糊查询+排序
	List<User> getUserlist(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("name") String name,@Param("isSort") String isSort) throws Exception;

	//查询用户
	List<Map<String,Object>> getUsermap();

	//根据id查询单个用户
	User getUserById(Integer userid);

	List<User> getUserxmid(Integer xmid);


}
